Formula Problems

Hi,

I am trying to set up a formula where I am trying to fine a specific # (i.e:20675) in Column A in another workbook. Once that value is found, I need to extract the values that is within that ROW. So for example: if I found the value "20675" in cell A62, then I would need find whatever value is in C62 (within that same row) and extract it.

Thanks in advace for any help.

Calli

Hi,

Think this might work for you. Say cell A1 has the # 20675 then enter this in cell B1

=VLOOKUP(A1,Sheet2!$A:$C,3,FALSE)

The formula

looks at A1 which is 20675
then looks at sheet2 columns A to C. Change sheet name if yours is different.
When it matches 20675 it returns value column 3

Learn more about vlookups from the below link

http://www.techonthenet.com/excel/formulas/vlookup.php

VBA Noob