vlookup to return 3 different columns

[Jane Fischer]

I do a vlookup to return 2 different columns depending on the value found. I need to add a 3rd column but am not sure the best way to do it. This is my current formula but now need to include column 6. Can someone help me figure this out?

=IFERROR(VLOOKUP(A2,'\\swfs04v01\fwal1shr\Plant-0\Finance\Other\WGS\[WGS P5 and TC Grinding Cost.xlsx]Sheet1'!$A$3:$E$974,4+(B2<"WGSTC"),0),0)

If B2=WGSTC return column 4
If B2=WGSP5 return column 5
If B2=WGSBS return column 6

 

[MrKowz]

Perhaps:

=IFERROR(VLOOKUP(A2,'\\swfs04v01\fwal1shr\Plant-0\Finance\Other\WGS\[WGS P5 and TC Grinding Cost.xlsx]Sheet1'!$A$3:$E$974,INDEX({4,5,6},MATCH(B2,{"WGSTC","WGSP5","WGSBS"},0)),0),0)

 

[Jane Fischer]

This only returns 0. Is there something else I am missing?

 

[T. Valko]

I do a vlookup to return 2 different columns depending on the value found. I need to add a 3rd column but am not sure the best way to do it. This is my current formula but now need to include column 6. Can someone help me figure this out?

=IFERROR(VLOOKUP(A2,'\\swfs04v01\fwal1shr\Plant-0\Finance\Other\WGS\[WGS P5 and TC Grinding Cost.xlsx]Sheet1'!$A$3:$E$974,4+(B2<"WGSTC"),0),0)

If B2=WGSTC return column 4
If B2=WGSP5 return column 5
If B2=WGSBS return column 6

But your table array only has 5 columns!

 

[Jane Fischer]

I have changed the table array to include all 6 columns and it still only returns 0 values.

 

[Jane Fischer]

I take that back. It was an error my part. Thanks for the help.

 

[T. Valko]

I take that back. It was an error my part. Thanks for the help.

Good deal. Thanks for the feedback!