Need help with VLookup then bring back value based on several IF statements

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

Maybe something like this?

=vlookup($B2,sheet2!$A$1:$c$100,if(vlookup($B2,sheet2!$A$1:$c$100,2,0)="Pints of water added",3,"whatever-else-you-need-here"),0)

Try the following array entered formula* for column C:

Formula:

Please Login or Register  to view this content.

Try the following array entered formula* for columns D and E:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.

*Array entered formulas are confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Did you change the sheet names in your file, and then reload it (in post 1)? My formula references sheet2, but that no longer exists (Table sheet now?)

also looks like you changed the text in post 1, too? My formula contained a test for "Pints of Water Added", no way would I have just added that, unless it was a requirement.

If you need to change/adjust the requirements, please do so in another post, dont change what you have already posted.

As Ford says, post-editing your posts is very unhelpful, and it means that what follows apppears to make no sense. I have, therefore, put back the text that you had edited out of your first post so that everybody can see and understand the flow of the thread.

Ali, thanks for that. Where did you find the original post? (I had started to think I was seeing things lol)

I'll PM you to explain.