Home |
Search |
Today's Posts |
#1
|
|||
|
|||
VLOOKUP (?)
glad it works - you have a great week too
"an" wrote in message ... Exactly, JulieD You helped me very much. Have you a good week. an -----Original Message----- Hi an then try =INDEX($A$1:$B$3,MATCH(C1,$B$1:$B$3,0),1) this will return a #NA error if the value is not found in column B to deal with this you can do something along the lines of =IF(ISNA(INDEX($A$1:$B$3,MATCH (C1,$B$1:$B$3,0),1)),"",INDEX($A$1:$B$3,MATCH (C1,$B$1:$B$3,0),1)) which says if the value in column C is not found in column B then return "nothing" otherwise match the values. Hope this helps Cheers JulieD "an" wrote in message ... Ooops! The formulae work fine... But, If to exist in "C" column a string without corresponding in "B" Column, the corresponding value in "D" Column, up one row (?). How is it possible to correct this, please? =IF(... Many thanks. an -----Original Message----- Hi an in D1 the formula would be =LOOKUP(C1,$B$1:$B$3,$A$1:$A$3) this formula can then be copied down column D Hope this helps Cheers JulieD "an" wrote in message . .. Ok. Thanks for your reply. I Have a block in A1:B3 (only) with corresponding numeric values in "A" and strings in "B" Column. But: I have a block in C1:C1000 with strins. Now: I would like a formulae to put in D1:D1000, where numerical values they were corresponding the same string for comparison between "A" and "B" columns. Thanks. an -----Original Message----- Hi could you provide a bit more detail ... in rows 1 &2 you have information in columns A, B, C and D - where C & D is the reverse of A & B. However, in row 3 this doesn't hold true. Then in rows 4 through 9 as far as i can tell you have data in columns C & D so i'm not really sure what you mean by a result in column D. Cheers JulieD "an" wrote in message . .. Hello! I would like formulae to result in Column D: A B C D 1 10 aaa aaa 10 2 11 bbb bbb 11 3 12 ccc aaa 10 4 ccc 12 5 ccc 12 6 aaa 10 7 bbb 11 8 aaa 10 9 aaa 10 10 ... ... Thanks in advance. an . . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Vlookup #N/A error due to formatting | Excel Worksheet Functions | |||
VLOOKUP not working | Excel Worksheet Functions | |||
Using Cell references in VLookUp | Excel Worksheet Functions | |||
vlookup. | Excel Worksheet Functions |