Help with COMPARE??? IF??? VLOOKUP??? Don't know which to use
in B1:
=VLOOKUP(A1,Sheet2!A:B,2,0)
To allow for errors:
=IF(ISNA(VLOOKUP(A1,Sheet2!A:B,2,0)),"Not found",VLOOKUP(A1,Sheet2!A:B,2,0))
"jessshouse" wrote:
I have two worksheets.
Worksheet 1
In column A1, I have the value SERVER1
In column A2, I have the value SERVER2
WORKSHEET2
Somewhere in column A, I have the value Sever1
Somewhere in column A, I have the value Server2
In column B I have a number 8.1.1 that coincides with the server name in
column A
(Server2 value might be 8.2)
I want to take the value located in coulmn B that associated with Server 1
(wherever it might be in column A)
and put it in cell B1 in Worksheet 1.
|