Hi All
In sheet 1 in column c "prod codes" are generated through a random button
The same "Prod codes" are already associated with "prod names" in details1.sheet
I have written a vlook up value to retrieve the prod name in the first sheet(try)
but it gives me an error "Not available" for all.
Not sure where i am going wrong. i have combined
iserror so that if any errors it can give some message
match so that it can give the prod name even if columns are inserted between the prodcode and prod.names in sheet2.
Please let me know if there is any mistake in my syntax. Also i wanted to know which is better to use a vlookup or a index+match
in your opinions.
Please Login or Register to view this content.
Bookmarks