Articles Comments

Free Excel Dashboards » Dashboard, Excel Dashboard, Excel Dashboard Software, IT » The Limitations of VLOOKUP and HLOOKUP

The Limitations of VLOOKUP and HLOOKUP

The VLOOKUP formula uses this format: =VLOOKUP(lookup_value, table_array, col_index_num, range_lookup) Let’s use this function to look up some values from this little database. To look up “G23″ in SKUs and return its description, we would use: =VLOOKUP(“G23″,$A$3:$C$7,2,FALSE) To look up “G23″ in SKUs and return its price, we would use: =VLOOKUP(“G23″,$A$3:$C$7,3,FALSE) To look up “Coats” [...]

For more information visit The Limitations of VLOOKUP and HLOOKUP

No related posts.

Related posts brought to you by Yet Another Related Posts Plugin.

Filed under: Dashboard, Excel Dashboard, Excel Dashboard Software, IT

Comments are closed.