Solved

Excel Formula and Link

Posted on 2014-11-24
1
79 Views
Last Modified: 2014-11-27
I have an XLS with two tabs

Main
wBPS

in Main I want a formula in a column that will look at MAIN column A and wBPS column A and when there is a match I want the contents of that cell to be http://www.test.com?ID= and the value from wBPS column C.  When there is no match there should be nothing in the column
0
Comment
Question by:Matt Pinkston
1 Comment
 
LVL 48

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 40462631
Hi,

pls try with xlsx or xlsxm

=IFERROR(HYPERLINK(" http://www.test.com?ID="&VLOOKUP(A3,wBPS!A3:C5,3)),"")

or with xls

=IF(ISERROR(VLOOKUP(A3,wBPS!A3:C5,3)),"",HYPERLINK(" http://www.test.com?ID="&VLOOKUP(A3,wBPS!A3:C5,3)))


Regards
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now