I have a worksheet with equipment numbers that I'll vlookup against a table. The table has the same equipment number several times in column A. However, based on what is in column B, I will bring back a value from column C.
I need to lookup equipment # from my spreadsheet to the table.
IF "FLOAT VOLTAGE" return value from column C in the table to column C2 in spreadsheet. Then return Date value from Column F in table, to Column D2 in Spreadsheet and value in Column G in table to column E2 in spreadsheet.
IF "UNINTENTIONAL GROUNDS" return value from column E in the table to column C3 in spreadsheet. Then return Date value from Column F in table, to Column D3 in Spreadsheet and value in Column G in table to column E3 in spreadsheet.
IF "WATER LEVEL OK" return value from column E in the table to column C4 in spreadsheet. Then return Date value from Column F in table, to Column D4 in Spreadsheet and value in Column G in table to column E4 in spreadsheet.
MOD EDIT Original text of this post (since edited out by OP):
I need to lookup equipment # from my spreadsheet to the table. Then if it is "PINTS OF WATER ADDED" I need to bring back the value of 4.00.
EXAMPLE: Spreadsheet that has equipment #'s
Location Equipment #
Area 1 2000773900
Area 2 2000767263
Area 3 2000773898
Area 4 2000839992
Area 5 2000839988
I need to lookup equipment # from my spreadsheet to the table.
2000773900 FLOAT VOLTAGE 134.50
2000773900 PINTS OF WATER ADDED 4.00
2000773898 FLOAT VOLTAGE 134.10
2000773898 FLOAT AMPS 4.20
Bookmarks