Worksheet RSS

NAVIGATION

Problem with LOOKUP function

A1 - "A" B1 - "B" C1 - "C" A2 - 3 B2 - 2 C2 - 1 D2= is returning the MAX in the A2:C2 array and returning 3 E2 is my LOOKUP function. =LOOKUP(D2,A2:C2,A1:C1) Which I thought was saying, look in the array a2:c2, find the value in d2(3), and return the corresponding value in the a1:c1 array, which...

5 answers | 600 bytes |

Problem with LOOKUP & VLOOKUP

I have data like this... A B C D Name Plan1 Plan2 Plan3 Tom 101 201 301 Alan 102 202 302 Mike 103 203 303 Brad 104 204 304 John 105 205 305 I need to get the correct value from D1 or D2 or D3 based on the name So I tried with both LOOKUP & VLOOKUP as below.. (i) =LOOKUP("Tom",$A2:$A6,$B2:$B6) --...

1 answers | 814 bytes |

Problem with LOOKUP & VLOOKUP

I tried now... But I get #N/A as the result.. any ideas.. -- ramsdes ---- ramsdesk's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1570 View this thread: http://www.excelforum.com/showthread.php?threadid=31422...

1 answers | 268 bytes |

Problem with LOOKUP & VLOOKUP

Sorry.. There was a typo in my first quote... Actually I tried with '2' only.. (ii) =VLOOLUP("Tom",$A2:$D6,2) --> Which should also be same.. -- ramsdes ---- ramsdesk's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1570 View this thread: http://www.excelfo...

0 answers | 373 bytes |

Problem with lists

My problem is probably very simple. When I create a list, it puts a border around the range but the drop down arrow is only visible when the box is selected. I have seen worksheet where there is no border and the drop down arrow, that indicates there is a list, is visible all the time. How is th...

1 answers | 328 bytes |

Problem with links not working correctly in spreadsheet

Hi We have a range of links in spreadsheets that are not working correctly. Below is an example of a link, that is exactly the same, displayed in two ways. =-'\\sydfp03\finance\FP&A\P&L\[BUDGET P&L VALUES.xls]Mgt 08'!$AO$55 =-'G:\FP&A\P&L\[BUDGET P&L VALUES.xls]Mgt 08'!$AO$55...

0 answers | 1089 bytes |

problem with linking data

I have a transaction file for a number of the accounts in .CSV generated daily from the bank. I need to import it to a cash report that is separating the transactions into proper accounts. Thus each account has a separate workbook. To link the data for a number of the transations is easy. The pr...

0 answers | 631 bytes |

Problem with link

How do ya link to functions together ? Like this: =if(b1=1;b1*9;b1*4) if(b1=2;b1*8;b1*4) How do u link these together '...

1 answers | 148 bytes |

Problem with length of validation list in Excel 2002

I've found a strange problem: I have a validation list containing several releases (information like 1.1 > 1.3, 1.0.2 etc.) However, for some reasons Excel doesn't show the entire list in the drop-down menu and limits the number of entries. Is there any restriction for the length of...

2 answers | 592 bytes |

problem with ISNA and VLOOKUP

accidentally posted this in General Need help with a formula.. Let's say I have "12/31/2000" in Sheet 1, Cell A1 and I need to see if this date is in a table in Sheet 2 and if it is it will return a value of "1" and if not it returns a value of "2" The formula I have is =IF(ISNA(VLOOKUP(A1,...

1 answers | 673 bytes |

problem with ISBLANK

Hi, I' m having a problem using isblank on multiple cells it seem only to work on a single cell. I'm looking for a formula to return a value of OK if the range of cells G50:G100 are all blank and a value of NO if there is Something in any of the cells. The something can be either alplh...

3 answers | 429 bytes |

Problem with IRR function

I am attempting to use the IRR function with a series of 121 payments. The first is positive, and all others are negative. When entering the function, the result displays as #NUM! I rechecked, and all are numbers. What's going on. I've pasted the numbers below for anyone who would like...

2 answers | 1656 bytes |

QUESTION ON "Worksheet"

DEVMSG.COM

Home- About Us- Contact- Privacy Statement- Link Exchange- Bookmark- Map.XML- Rss.Xml
0.203