+ Reply to Thread
Results 1 to 3 of 3

Vlookup looking at a cell with formula

  1. #1
    Registered User
    Join Date
    03-11-2022
    Location
    San Diego, CA
    MS-Off Ver
    Microsoft® Excel® for Microsoft 365
    Posts
    4

    Vlookup looking at a cell with formula

    Hello,

    I am trying to do a vlookup using a cell that has a formula in it. Can someone please assist? I have a attached a file to show what I am trying to do. formula help.xlsx

    Basically, it is finding out if an actual salary is included on a list of salaries and returning a "Yes"/"No". (Does the ACTUAL SALARY exactly MATCH anything on the list?)

    Thanks so much!
    Last edited by Schulky; 08-14-2024 at 07:23 AM.

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,780

    Re: Vlookup looking at a cell with formula

    You could use:

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Everyone who confuses correlation and causation ends up dead.

  3. #3
    Registered User
    Join Date
    03-11-2022
    Location
    San Diego, CA
    MS-Off Ver
    Microsoft® Excel® for Microsoft 365
    Posts
    4

    Re: Vlookup looking at a cell with formula

    Thank you so much!!! It worked!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Using xlookup/vlookup formula into a validated cell to return a value into that cell
    By Questray in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-14-2020, 11:51 AM
  2. [SOLVED] VLOOKUP formula that also can prevent the cell from showing a 0 if the Cell is blank
    By JJAngel in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-20-2019, 03:25 PM
  3. Replies: 5
    Last Post: 12-07-2016, 09:18 AM
  4. VBA external VLOOKUP instead of VLOOKUP-formula in cell
    By ExcelBonk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-07-2016, 02:41 PM
  5. Replies: 6
    Last Post: 10-03-2014, 12:18 PM
  6. [SOLVED] IF(VLOOKUP) Formula That also Copies Cell Background Color to Target Cell
    By JRidge in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-09-2014, 06:38 AM
  7. [SOLVED] IF(VLOOKUP) Formula That also Copies Cell Background Color to Target Cell
    By JRidge in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-04-2014, 05:32 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1