AgTalk Home
AgTalk Home
Search Forums | Classifieds (127) | Skins | Language
You are logged in as a guest. ( logon | register )

Google Sheets help
View previous thread :: View next thread
   Forums List -> Computer TalkMessage format
 
Omar
Posted 9/6/2019 20:45 (#7719294 - in reply to #7719166)
Subject: RE: Google Sheets help


Elmira, Ontario

I'm not into Google Sheets, but if the Vlookup is the same as Excel, you need to tell it one more thing.

=VLOOKUP(A4,Sheet2!$A4:$B13,2, FALSE)

The reason is the default is to have an approximate match. If the price codes aren't sorted, or if you try for a code that doesn't exist, then you might get a false answer. In this case, you need an exact match, which is what FALSE forces.

Top of the page Bottom of the page


Jump to forum :
Search this forum
Printer friendly version
E-mail a link to this thread

(Delete cookies)