How would you use the VLOOKUP function to find the weather on Thursday?
https://d2vlcm61l7u1fs.cloudfront.net/media%2Faee%2Faeee8e0c-ba89-4dd5-a8ff-2cb8db6cfd4b%2Fphpb8Opse.png
=VLOOKUP(“Thursday”,$A$1:$C$8,3,False)
=VLOOKUP(“Thursday”,$A$1:$C$8,2,False)
=VLOOKUP(“Thursday”,$A$1:$C$1,4,False)
=VLOOKUP(“Thursday”,$A$1:$C$8,3,True)
Expert Answer
VLOOKUP function to find the weather on Thursday =
value,table, col_index, [range_lookup] =
value = the value to look for in the first column of the table
table = the table from which to retrieve a value
col_index = the column in the table from which to retrieve a value
range_lookup =
optional (true), approximate match (default), False (exact match)
option 2. VLOOKUP(“Thursday”, $A$1:$C$8,2,TRUE)