If-Then Statement

A

alanf

This is the formula I put in..... it put the table names with a
underscore when I went to define.... so I changed it in the formula.

=VLOOKUP(B2,CHOOSE(MATCH(C2,{"Quick_Freight","Gamecock_Freight"},0),Quick_Freight,Gamecock_Freight),2)

It is coming up #N/A with that formula, for everything.
And without the underscore or spaces.... it came up #NAME
 
D

Domenic

alanf said:
This is the formula I put in..... it put the table names with a
underscore when I went to define.... so I changed it in the formula.

=VLOOKUP(B2,CHOOSE(MATCH(C2,{"Quick_Freight","Gamecock_Freight"},0),Quick_Freight,Gamecock_Freight),2)

It is coming up #N/A with that formula, for everything.
And without the underscore or spaces.... it came up #NAME?
Click to expand...

The underscore for the defined names is ok, but not for the names i
the array constant {....}, since they should match the format used whe
entering the name for the company used in Column C. So try th
following...

VLOOKUP(B2,CHOOSE(MATCH(C2,{"Quick Freight","Gamecoc
Freight"},0),Quick_Freight,Gamecock_Freight),2)

Does this help
 
Top