IF statement that looks at 3 different tabs for information

[apmi]

Hello,

I have attached the copy of the spreadsheet I am working on. I have removed all the other formulas that I have in it already.

What I am trying to do is an IF statement that would do a vlookup on different tabs.

The tab called "South" has column C (HP Tap).
In column E is where I want the IF statement to go.
I want the IF statement to look at the tabs "South Integrated Systems", "South Isolated Systems MODELLED" and South Isol Systems NOT MODELLED" base on the tap number (in the South tab) and show me the 2019 numbers in the tabs mentioned above.

For example the first HP tap in the South tab is 16999. It has a 2019 number in the South Isol Systems NOT MODELLED tab. I can do a vlookup but that ended up with three different columns.

I've tried to google this and haven't found anything that would work.

Please help!

Thank you!

[daffodil11]

Please Login or Register  to view this content.

and copy down

[mcmahobt]

Entered into E2 and dragged down:

Please Login or Register  to view this content.

[Special-K]

Try this

in E2
=IFERROR(VLOOKUP(C2,'South Integrated Systems'!A2:B928,2,0),IFERROR(VLOOKUP(C2,'South Isolated Systems MODELLED'!A2:B928,2,0),IFERROR(VLOOKUP(C2,'South Isol Systems NOT MODELLED'!A2:B928,2,0),"")))

and copy down

Your lookup tables are in a bit of a mess.
Note also the return value for 16999 is displayed as 4789.5 but the value is actually 4789.4652

[apmi]

Thank you!
I thought I had to have something in between each of the vlookups so i kept on getting the too many error message.