Results 1 to 5 of 5

Lookup and match corresponding value

Threaded View

shamshersadiq Lookup and match... 08-06-2016, 06:12 AM
Glenn Kennedy Re: Lookup and match... 08-06-2016, 06:16 AM
Pete_UK Re: Lookup and match... 08-06-2016, 06:16 AM
shamshersadiq Re: Lookup and match... 08-06-2016, 06:23 AM
Pete_UK Re: Lookup and match... 08-06-2016, 07:36 AM
  1. #1
    Registered User
    Join Date
    01-26-2016
    Location
    seoul,south korea
    MS-Off Ver
    2013
    Posts
    23

    Lookup and match corresponding value

    Lookup a match of every value of C in column A,if it matches then print Corresponding value in D

    Example:

    Example:
    C1=89.5 is A5=89.5 both matches so D1=715.1

    Please see attached sheet.

    Thanks in advance
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Lookup/Match from 2 worksheet & populate data based on lookup
    By plcouch in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-22-2015, 08:16 PM
  2. [SOLVED] How to Match or Lookup the the qty to other specific cell that match the date
    By JESSHOR60 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-11-2015, 04:20 AM
  3. Replies: 3
    Last Post: 06-17-2013, 12:37 PM
  4. Match/Index/Lookup - Searching From Bottom to Top (A reverse lookup maybe)
    By Neutralizer in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-02-2013, 03:55 AM
  5. Replies: 7
    Last Post: 06-19-2011, 12:51 PM
  6. Replies: 5
    Last Post: 02-24-2011, 11:26 AM
  7. Lookup? Match? pulling rows from one spreadsheet to match a text f
    By cjax in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-21-2006, 09:51 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