Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Vlookup formula Excel version 2002
I want column A to be the lookup column and compare to column B. The results
in column C will be the row items that are equal in both columns A & B. I need a vlookup formula for this. Example: Column A 1 11 2 Column B 2 35 8 11 Column C (Vlookup formula Results) 2 11 In addition if you are able to give me the vlookup formula for the ablove, is it possible to use column A as vlookup & compare against 2 other columns at the same time (i.e. column D & E) to check if there are similar row items in columns D & E? Thanks -- biz -- biz |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup Formula Excel Version 2002 | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
how to convert GETPIVOTDATA from excel 2000 to excel 2002... | Excel Worksheet Functions | |||
Formula Arrays VERY SLOW in Excel 2002 | Excel Worksheet Functions | |||
How do I view the actual numeric value of a formula in Excel 2002. | Excel Worksheet Functions |