1 / 8

Lookup function

Lookup function. There two lookup function Hlookup function . it use look for a value from income table in the row , with metode income as horisontal or per row The form function hlookup ( lookup_value;table_array;col_index_num;range_lookup ). v lookup function .

chill
Download Presentation

Lookup function

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Lookup function There two lookup function Hlookup function . it use look for a value from income table in the row , with metode income as horisontal or per row The form function hlookup(lookup_value;table_array;col_index_num;range_lookup)

  2. vlookup function . it use look for a value from income table in the coloumn , with metode income as vertical or per coloumn The form function vlookup(lookup_value;table_array;col_index_num;range_lookup

  3. Information the function Lookup value is value that will look for or test to comparison Table array is help area table as comparison data (tabel area must constant value /absolut, with press button F4) Row index num is number of row that read as decision Col index num is number of coloumn that read as decision Range lookup is act of determining value product.

  4. Information the picture Put cursor in cell D3 Write =hlookup(c3, Then blok cell b10 until e11, then press button F4. Then press button 2 then 0 press button ) then enter

  5. Information the picture Put cursor in cell D3 Write =Vlookup(c3, Then blok cell A11 until B14, then press button F4. Then press button 2 then 0 press button ) then enter

More Related