Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Does any know how to use the LOOKUP func in Excel?

April 26, 2017Computers Excel func internet lookup Software

0

Posted

Does any know how to use the LOOKUP func in Excel?

1 Answer

0

Posted

a normal vlookup looks like this =vlookup(lookup_value, table_array, col_index_num, [range_lookup] and if i understand what you want to do correctly, this is how it would look like =vlookup(student’s name, your grade chart, the # of column where the actual grade shows based on your grade chart, FALSE) of course this should show cell positions. what excel will do is find the students name on your grade chart and will return the value on the # of column you have indicated from your grade chart. hope that helps..