I keep getting and invalid data type error for my VLOOKUP formula

Yvette

I have to sheets in my workspace, one contains system generated authorization numbers, and the other tracks requisitions. I want to populate the credit card authorization numbers from one sheet onto the requisition tracking sheet. I am using the following formula. The value returned is a combo of number and text. The requisition number is the primary value on both sheets. Is the fact that the value I am trying to return is system generated causing an issue?

=VLOOKUP([Requisition Number]@row; {CPC AUTHS Range 1}; 4)

Paul Newcome

FOr the Incorrect Argument Error, double check your range to ensure it has at least 4 columns included with the first column be the column that houses the data to match on.

Sam M.

Hi Yvette,

I might be wrong, but did you use this formula exactly?

=VLOOKUP([Requisition Number]@row; {CPC AUTHS Range 1}; 4)

if so, try changing the ";" to "," that might be causing an error of #UNPARSEABLE.

The formula would end up like this:

=VLOOKUP([Requisition Number]@row, {CPC AUTHS Range 1}, 4)

You can also try:

=VLOOKUP([Requisition Number]@row, {CPC AUTHS Range 1}, 4,false)

If it does not work, please let me know the error that it gives you.

Hope it helps!

Samantha

Yvette

Now it is saying incorrect argument

Paul Newcome

FOr the Incorrect Argument Error, double check your range to ensure it has at least 4 columns included with the first column be the column that houses the data to match on.