Google Sheets vLookup issue

Trying to insert the following formula: =vlookup(C2,IMPORTRANGE("LINK","AA!c1:c2978"),6,0) to lookup between to different sheets
but it keeps telling me VLOOKUP evaluates to an out of bounds range.
Both files are attached plz help

docs.google.com/spreadsheets/d/1NaEnJOTaEb5IRGsPB5uZGxNrnhyx6vbH3FHpn5rQwlo/edit#gid=1807590520
docs.google.com/spreadsheets/d/1R-mUNdo_hCX5R50_oTbMQq5rAHNXUVGtCKz7YnuRhOE/edit?usp=sharing

Hi ahmadjw,

What is your expected result for cell C2?

to get the match row from the column number 6

If you want to return the result from col F use

Formula:

Please Login or Register  to view this content.

I wanto to return the result of column I.. i did the following but still not work

=vlookup(C2,IMPORTRANGE("docs.google.com/spreadsheets/d/1NaEnJOTaEb5IRGsPB5uZGxNrnhyx6vbH3FHpn5rQwlo/edit#gid=1807590520","AA!C1:C2978"),6,0)

it keeps telling me VLOOKUP evaluates to an out of bounds range.

In that case it should be

Formula:

Please Login or Register  to view this content.

I beleavie its worked .. thx alot dear for your help .. much appreciated

You're welcome & thanks for the feedback.