VLOOKUP on a VLOOKUP result returns #VALUE!

[FACTOR 21]

Hi

I am trying to run a VLOOKUP on the result of a previous VLOOKUP but the formula returns #VALUE!

I am using this formula - =VLOOKUP(VALUE(C6),'Instructors 2021'!A:H,2,FALSE)

where C6 is the result of the initial VLOOKUP.

Any help would be appreciated.

Jeremy

 

[Fluff]

Is C6 a number or text?

 

[FACTOR 21]

Is C6 a number or text?

C6 is Text

 

[Fluff]

In that case use

=VLOOKUP(C6,'Instructors 2021'!A:H,2,FALSE)

 

[FACTOR 21]

In that case use

=VLOOKUP(C6,'Instructors 2021'!A:H,2,FALSE)

That now returns #N/A

 

[Fluff]

In that case it cannot find the value in C6 in col A of the instructors sheet.

 

[FACTOR 21]

In that case it cannot find the value in C6 in col A of the instructors sheet.

It was in column A and formatted as text, but was not recognised, in the end I changed the format of the ID from IN001 to 001 and all worked!!

 

[Fluff]

Glad you sorted it & thanks for the feedback.

 

[FACTOR 21]

Glad you sorted it & thanks for the feedback.

No problem, just going to post another query